package com.foreknow.springboot.mapper;

import com.foreknow.springboot.po.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.sql.SQLException;

@Mapper
public interface UserMapper {
    /**
     * 根据用户编号与密码查询用户信息
     *
     * @param userId
     * @param password
     * @return
     */
    @Select("SELECT*FROM `user` WHERE userId = #{userId} AND `password` = #{password}")
    public User getUserByIdByPass(String userId, String password);

    /**
     * 根据用户编号查询用户表返回的行数
     *
     * @param userId
     * @return
     */
    @Select("SELECT COUNT(*) AS nums FROM `user` WHERE userId = #{userId}")
    public int getUserById(String userId);

    /**
     * 向用户表中添加一条记录
     * @param userId
     * @param password
     * @param userName
     * @param userSex
     * @return
     */
    @Insert("INSERT INTO `user`(userId,`password`,userName,userSex) VALUES(#{userId},#{password},#{userName},#{userSex})")
    public int saveUser(String userId, String password, String userName, Integer userSex);

}
